package com.zj.fx.model.rpa;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

import cn.hutool.core.util.StrUtil;

/**
 * RPA月度数据有效转换数据 RpaTransdataExample
 * @author SQL_自动生成
 * @date 2023-11-27 10:53:02
 */
public class RpaTransdataExample {

    protected String orderByClause;

    protected boolean distinct;
    protected List<Criteria> oredCriteria;

    public RpaTransdataExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        
            public Criteria andIdIsNull() {
                addCriterion("id is null");
                return (Criteria) this;
            }

            public Criteria andIdIsNotNull() {
                addCriterion("id is not null");
                return (Criteria) this;
            }

            public Criteria andIdEqualTo(String value) {
                addCriterion("id =", value, "id");
                return (Criteria) this;
            }

            public Criteria andIdNotEqualTo(String value) {
                addCriterion("id <>", value, "id");
                return (Criteria) this;
            }

            public Criteria andIdGreaterThan(String value) {
                addCriterion("id >", value, "id");
                return (Criteria) this;
            }

            public Criteria andIdGreaterThanOrEqualTo(String value) {
                addCriterion("id >=", value, "id");
                return (Criteria) this;
            }

            public Criteria andIdLessThan(String value) {
                addCriterion("id <", value, "id");
                return (Criteria) this;
            }

            public Criteria andIdLessThanOrEqualTo(String value) {
                addCriterion("id <=", value, "id");
                return (Criteria) this;
            }

            public Criteria andIdLike(String value) {
                addCriterion("id like", value, "id");
                return (Criteria) this;
            }

            public Criteria andIdNotLike(String value) {
                addCriterion("id not like", value, "id");
                return (Criteria) this;
            }

            public Criteria andIdIn(List<String> values) {
                addCriterion("id in", values, "id");
                return (Criteria) this;
            }

            public Criteria andIdNotIn(List<String> values) {
                addCriterion("id not in", values, "id");
                return (Criteria) this;
            }

            public Criteria andIdBetween(String value1, String value2) {
                addCriterion("id between", value1, value2, "id");
                return (Criteria) this;
            }

            public Criteria andIdNotBetween(String value1, String value2) {
                addCriterion("id not between", value1, value2, "id");
                return (Criteria) this;
            }

        
            public Criteria andTypenumIsNull() {
                addCriterion("typenum is null");
                return (Criteria) this;
            }

            public Criteria andTypenumIsNotNull() {
                addCriterion("typenum is not null");
                return (Criteria) this;
            }

            public Criteria andTypenumEqualTo(String value) {
                addCriterion("typenum =", value, "typenum");
                return (Criteria) this;
            }

            public Criteria andTypenumNotEqualTo(String value) {
                addCriterion("typenum <>", value, "typenum");
                return (Criteria) this;
            }

            public Criteria andTypenumGreaterThan(String value) {
                addCriterion("typenum >", value, "typenum");
                return (Criteria) this;
            }

            public Criteria andTypenumGreaterThanOrEqualTo(String value) {
                addCriterion("typenum >=", value, "typenum");
                return (Criteria) this;
            }

            public Criteria andTypenumLessThan(String value) {
                addCriterion("typenum <", value, "typenum");
                return (Criteria) this;
            }

            public Criteria andTypenumLessThanOrEqualTo(String value) {
                addCriterion("typenum <=", value, "typenum");
                return (Criteria) this;
            }

            public Criteria andTypenumLike(String value) {
                addCriterion("typenum like", value, "typenum");
                return (Criteria) this;
            }

            public Criteria andTypenumNotLike(String value) {
                addCriterion("typenum not like", value, "typenum");
                return (Criteria) this;
            }

            public Criteria andTypenumIn(List<String> values) {
                addCriterion("typenum in", values, "typenum");
                return (Criteria) this;
            }

            public Criteria andTypenumNotIn(List<String> values) {
                addCriterion("typenum not in", values, "typenum");
                return (Criteria) this;
            }

            public Criteria andTypenumBetween(String value1, String value2) {
                addCriterion("typenum between", value1, value2, "typenum");
                return (Criteria) this;
            }

            public Criteria andTypenumNotBetween(String value1, String value2) {
                addCriterion("typenum not between", value1, value2, "typenum");
                return (Criteria) this;
            }

        
            public Criteria andTypenameIsNull() {
                addCriterion("typename is null");
                return (Criteria) this;
            }

            public Criteria andTypenameIsNotNull() {
                addCriterion("typename is not null");
                return (Criteria) this;
            }

            public Criteria andTypenameEqualTo(String value) {
                addCriterion("typename =", value, "typename");
                return (Criteria) this;
            }

            public Criteria andTypenameNotEqualTo(String value) {
                addCriterion("typename <>", value, "typename");
                return (Criteria) this;
            }

            public Criteria andTypenameGreaterThan(String value) {
                addCriterion("typename >", value, "typename");
                return (Criteria) this;
            }

            public Criteria andTypenameGreaterThanOrEqualTo(String value) {
                addCriterion("typename >=", value, "typename");
                return (Criteria) this;
            }

            public Criteria andTypenameLessThan(String value) {
                addCriterion("typename <", value, "typename");
                return (Criteria) this;
            }

            public Criteria andTypenameLessThanOrEqualTo(String value) {
                addCriterion("typename <=", value, "typename");
                return (Criteria) this;
            }

            public Criteria andTypenameLike(String value) {
                addCriterion("typename like", value, "typename");
                return (Criteria) this;
            }

            public Criteria andTypenameNotLike(String value) {
                addCriterion("typename not like", value, "typename");
                return (Criteria) this;
            }

            public Criteria andTypenameIn(List<String> values) {
                addCriterion("typename in", values, "typename");
                return (Criteria) this;
            }

            public Criteria andTypenameNotIn(List<String> values) {
                addCriterion("typename not in", values, "typename");
                return (Criteria) this;
            }

            public Criteria andTypenameBetween(String value1, String value2) {
                addCriterion("typename between", value1, value2, "typename");
                return (Criteria) this;
            }

            public Criteria andTypenameNotBetween(String value1, String value2) {
                addCriterion("typename not between", value1, value2, "typename");
                return (Criteria) this;
            }

        
            public Criteria andThirdidIsNull() {
                addCriterion("thirdid is null");
                return (Criteria) this;
            }

            public Criteria andThirdidIsNotNull() {
                addCriterion("thirdid is not null");
                return (Criteria) this;
            }

            public Criteria andThirdidEqualTo(String value) {
                addCriterion("thirdid =", value, "thirdid");
                return (Criteria) this;
            }

            public Criteria andThirdidNotEqualTo(String value) {
                addCriterion("thirdid <>", value, "thirdid");
                return (Criteria) this;
            }

            public Criteria andThirdidGreaterThan(String value) {
                addCriterion("thirdid >", value, "thirdid");
                return (Criteria) this;
            }

            public Criteria andThirdidGreaterThanOrEqualTo(String value) {
                addCriterion("thirdid >=", value, "thirdid");
                return (Criteria) this;
            }

            public Criteria andThirdidLessThan(String value) {
                addCriterion("thirdid <", value, "thirdid");
                return (Criteria) this;
            }

            public Criteria andThirdidLessThanOrEqualTo(String value) {
                addCriterion("thirdid <=", value, "thirdid");
                return (Criteria) this;
            }

            public Criteria andThirdidLike(String value) {
                addCriterion("thirdid like", value, "thirdid");
                return (Criteria) this;
            }

            public Criteria andThirdidNotLike(String value) {
                addCriterion("thirdid not like", value, "thirdid");
                return (Criteria) this;
            }

            public Criteria andThirdidIn(List<String> values) {
                addCriterion("thirdid in", values, "thirdid");
                return (Criteria) this;
            }

            public Criteria andThirdidNotIn(List<String> values) {
                addCriterion("thirdid not in", values, "thirdid");
                return (Criteria) this;
            }

            public Criteria andThirdidBetween(String value1, String value2) {
                addCriterion("thirdid between", value1, value2, "thirdid");
                return (Criteria) this;
            }

            public Criteria andThirdidNotBetween(String value1, String value2) {
                addCriterion("thirdid not between", value1, value2, "thirdid");
                return (Criteria) this;
            }

        
            public Criteria andTaskmonthIsNull() {
                addCriterion("taskmonth is null");
                return (Criteria) this;
            }

            public Criteria andTaskmonthIsNotNull() {
                addCriterion("taskmonth is not null");
                return (Criteria) this;
            }

            public Criteria andTaskmonthEqualTo(String value) {
                addCriterion("taskmonth =", value, "taskmonth");
                return (Criteria) this;
            }

            public Criteria andTaskmonthNotEqualTo(String value) {
                addCriterion("taskmonth <>", value, "taskmonth");
                return (Criteria) this;
            }

            public Criteria andTaskmonthGreaterThan(String value) {
                addCriterion("taskmonth >", value, "taskmonth");
                return (Criteria) this;
            }

            public Criteria andTaskmonthGreaterThanOrEqualTo(String value) {
                addCriterion("taskmonth >=", value, "taskmonth");
                return (Criteria) this;
            }

            public Criteria andTaskmonthLessThan(String value) {
                addCriterion("taskmonth <", value, "taskmonth");
                return (Criteria) this;
            }

            public Criteria andTaskmonthLessThanOrEqualTo(String value) {
                addCriterion("taskmonth <=", value, "taskmonth");
                return (Criteria) this;
            }

            public Criteria andTaskmonthLike(String value) {
                addCriterion("taskmonth like", value, "taskmonth");
                return (Criteria) this;
            }

            public Criteria andTaskmonthNotLike(String value) {
                addCriterion("taskmonth not like", value, "taskmonth");
                return (Criteria) this;
            }

            public Criteria andTaskmonthIn(List<String> values) {
                addCriterion("taskmonth in", values, "taskmonth");
                return (Criteria) this;
            }

            public Criteria andTaskmonthNotIn(List<String> values) {
                addCriterion("taskmonth not in", values, "taskmonth");
                return (Criteria) this;
            }

            public Criteria andTaskmonthBetween(String value1, String value2) {
                addCriterion("taskmonth between", value1, value2, "taskmonth");
                return (Criteria) this;
            }

            public Criteria andTaskmonthNotBetween(String value1, String value2) {
                addCriterion("taskmonth not between", value1, value2, "taskmonth");
                return (Criteria) this;
            }

        
            public Criteria andSubcompanynameIsNull() {
                addCriterion("subcompanyname is null");
                return (Criteria) this;
            }

            public Criteria andSubcompanynameIsNotNull() {
                addCriterion("subcompanyname is not null");
                return (Criteria) this;
            }

            public Criteria andSubcompanynameEqualTo(String value) {
                addCriterion("subcompanyname =", value, "subcompanyname");
                return (Criteria) this;
            }

            public Criteria andSubcompanynameNotEqualTo(String value) {
                addCriterion("subcompanyname <>", value, "subcompanyname");
                return (Criteria) this;
            }

            public Criteria andSubcompanynameGreaterThan(String value) {
                addCriterion("subcompanyname >", value, "subcompanyname");
                return (Criteria) this;
            }

            public Criteria andSubcompanynameGreaterThanOrEqualTo(String value) {
                addCriterion("subcompanyname >=", value, "subcompanyname");
                return (Criteria) this;
            }

            public Criteria andSubcompanynameLessThan(String value) {
                addCriterion("subcompanyname <", value, "subcompanyname");
                return (Criteria) this;
            }

            public Criteria andSubcompanynameLessThanOrEqualTo(String value) {
                addCriterion("subcompanyname <=", value, "subcompanyname");
                return (Criteria) this;
            }

            public Criteria andSubcompanynameLike(String value) {
                addCriterion("subcompanyname like", value, "subcompanyname");
                return (Criteria) this;
            }

            public Criteria andSubcompanynameNotLike(String value) {
                addCriterion("subcompanyname not like", value, "subcompanyname");
                return (Criteria) this;
            }

            public Criteria andSubcompanynameIn(List<String> values) {
                addCriterion("subcompanyname in", values, "subcompanyname");
                return (Criteria) this;
            }

            public Criteria andSubcompanynameNotIn(List<String> values) {
                addCriterion("subcompanyname not in", values, "subcompanyname");
                return (Criteria) this;
            }

            public Criteria andSubcompanynameBetween(String value1, String value2) {
                addCriterion("subcompanyname between", value1, value2, "subcompanyname");
                return (Criteria) this;
            }

            public Criteria andSubcompanynameNotBetween(String value1, String value2) {
                addCriterion("subcompanyname not between", value1, value2, "subcompanyname");
                return (Criteria) this;
            }

        
            public Criteria andSupplynameIsNull() {
                addCriterion("supplyname is null");
                return (Criteria) this;
            }

            public Criteria andSupplynameIsNotNull() {
                addCriterion("supplyname is not null");
                return (Criteria) this;
            }

            public Criteria andSupplynameEqualTo(String value) {
                addCriterion("supplyname =", value, "supplyname");
                return (Criteria) this;
            }

            public Criteria andSupplynameNotEqualTo(String value) {
                addCriterion("supplyname <>", value, "supplyname");
                return (Criteria) this;
            }

            public Criteria andSupplynameGreaterThan(String value) {
                addCriterion("supplyname >", value, "supplyname");
                return (Criteria) this;
            }

            public Criteria andSupplynameGreaterThanOrEqualTo(String value) {
                addCriterion("supplyname >=", value, "supplyname");
                return (Criteria) this;
            }

            public Criteria andSupplynameLessThan(String value) {
                addCriterion("supplyname <", value, "supplyname");
                return (Criteria) this;
            }

            public Criteria andSupplynameLessThanOrEqualTo(String value) {
                addCriterion("supplyname <=", value, "supplyname");
                return (Criteria) this;
            }

            public Criteria andSupplynameLike(String value) {
                addCriterion("supplyname like", value, "supplyname");
                return (Criteria) this;
            }

            public Criteria andSupplynameNotLike(String value) {
                addCriterion("supplyname not like", value, "supplyname");
                return (Criteria) this;
            }

            public Criteria andSupplynameIn(List<String> values) {
                addCriterion("supplyname in", values, "supplyname");
                return (Criteria) this;
            }

            public Criteria andSupplynameNotIn(List<String> values) {
                addCriterion("supplyname not in", values, "supplyname");
                return (Criteria) this;
            }

            public Criteria andSupplynameBetween(String value1, String value2) {
                addCriterion("supplyname between", value1, value2, "supplyname");
                return (Criteria) this;
            }

            public Criteria andSupplynameNotBetween(String value1, String value2) {
                addCriterion("supplyname not between", value1, value2, "supplyname");
                return (Criteria) this;
            }

        
            public Criteria andSelfsupplyidIsNull() {
                addCriterion("selfsupplyid is null");
                return (Criteria) this;
            }

            public Criteria andSelfsupplyidIsNotNull() {
                addCriterion("selfsupplyid is not null");
                return (Criteria) this;
            }

            public Criteria andSelfsupplyidEqualTo(String value) {
                addCriterion("selfsupplyid =", value, "selfsupplyid");
                return (Criteria) this;
            }

            public Criteria andSelfsupplyidNotEqualTo(String value) {
                addCriterion("selfsupplyid <>", value, "selfsupplyid");
                return (Criteria) this;
            }

            public Criteria andSelfsupplyidGreaterThan(String value) {
                addCriterion("selfsupplyid >", value, "selfsupplyid");
                return (Criteria) this;
            }

            public Criteria andSelfsupplyidGreaterThanOrEqualTo(String value) {
                addCriterion("selfsupplyid >=", value, "selfsupplyid");
                return (Criteria) this;
            }

            public Criteria andSelfsupplyidLessThan(String value) {
                addCriterion("selfsupplyid <", value, "selfsupplyid");
                return (Criteria) this;
            }

            public Criteria andSelfsupplyidLessThanOrEqualTo(String value) {
                addCriterion("selfsupplyid <=", value, "selfsupplyid");
                return (Criteria) this;
            }

            public Criteria andSelfsupplyidLike(String value) {
                addCriterion("selfsupplyid like", value, "selfsupplyid");
                return (Criteria) this;
            }

            public Criteria andSelfsupplyidNotLike(String value) {
                addCriterion("selfsupplyid not like", value, "selfsupplyid");
                return (Criteria) this;
            }

            public Criteria andSelfsupplyidIn(List<String> values) {
                addCriterion("selfsupplyid in", values, "selfsupplyid");
                return (Criteria) this;
            }

            public Criteria andSelfsupplyidNotIn(List<String> values) {
                addCriterion("selfsupplyid not in", values, "selfsupplyid");
                return (Criteria) this;
            }

            public Criteria andSelfsupplyidBetween(String value1, String value2) {
                addCriterion("selfsupplyid between", value1, value2, "selfsupplyid");
                return (Criteria) this;
            }

            public Criteria andSelfsupplyidNotBetween(String value1, String value2) {
                addCriterion("selfsupplyid not between", value1, value2, "selfsupplyid");
                return (Criteria) this;
            }

        
            public Criteria andSelfsupplynameIsNull() {
                addCriterion("selfsupplyname is null");
                return (Criteria) this;
            }

            public Criteria andSelfsupplynameIsNotNull() {
                addCriterion("selfsupplyname is not null");
                return (Criteria) this;
            }

            public Criteria andSelfsupplynameEqualTo(String value) {
                addCriterion("selfsupplyname =", value, "selfsupplyname");
                return (Criteria) this;
            }

            public Criteria andSelfsupplynameNotEqualTo(String value) {
                addCriterion("selfsupplyname <>", value, "selfsupplyname");
                return (Criteria) this;
            }

            public Criteria andSelfsupplynameGreaterThan(String value) {
                addCriterion("selfsupplyname >", value, "selfsupplyname");
                return (Criteria) this;
            }

            public Criteria andSelfsupplynameGreaterThanOrEqualTo(String value) {
                addCriterion("selfsupplyname >=", value, "selfsupplyname");
                return (Criteria) this;
            }

            public Criteria andSelfsupplynameLessThan(String value) {
                addCriterion("selfsupplyname <", value, "selfsupplyname");
                return (Criteria) this;
            }

            public Criteria andSelfsupplynameLessThanOrEqualTo(String value) {
                addCriterion("selfsupplyname <=", value, "selfsupplyname");
                return (Criteria) this;
            }

            public Criteria andSelfsupplynameLike(String value) {
                addCriterion("selfsupplyname like", value, "selfsupplyname");
                return (Criteria) this;
            }

            public Criteria andSelfsupplynameNotLike(String value) {
                addCriterion("selfsupplyname not like", value, "selfsupplyname");
                return (Criteria) this;
            }

            public Criteria andSelfsupplynameIn(List<String> values) {
                addCriterion("selfsupplyname in", values, "selfsupplyname");
                return (Criteria) this;
            }

            public Criteria andSelfsupplynameNotIn(List<String> values) {
                addCriterion("selfsupplyname not in", values, "selfsupplyname");
                return (Criteria) this;
            }

            public Criteria andSelfsupplynameBetween(String value1, String value2) {
                addCriterion("selfsupplyname between", value1, value2, "selfsupplyname");
                return (Criteria) this;
            }

            public Criteria andSelfsupplynameNotBetween(String value1, String value2) {
                addCriterion("selfsupplyname not between", value1, value2, "selfsupplyname");
                return (Criteria) this;
            }

        
            public Criteria andDatamemoIsNull() {
                addCriterion("datamemo is null");
                return (Criteria) this;
            }

            public Criteria andDatamemoIsNotNull() {
                addCriterion("datamemo is not null");
                return (Criteria) this;
            }

            public Criteria andDatamemoEqualTo(String value) {
                addCriterion("datamemo =", value, "datamemo");
                return (Criteria) this;
            }

            public Criteria andDatamemoNotEqualTo(String value) {
                addCriterion("datamemo <>", value, "datamemo");
                return (Criteria) this;
            }

            public Criteria andDatamemoGreaterThan(String value) {
                addCriterion("datamemo >", value, "datamemo");
                return (Criteria) this;
            }

            public Criteria andDatamemoGreaterThanOrEqualTo(String value) {
                addCriterion("datamemo >=", value, "datamemo");
                return (Criteria) this;
            }

            public Criteria andDatamemoLessThan(String value) {
                addCriterion("datamemo <", value, "datamemo");
                return (Criteria) this;
            }

            public Criteria andDatamemoLessThanOrEqualTo(String value) {
                addCriterion("datamemo <=", value, "datamemo");
                return (Criteria) this;
            }

            public Criteria andDatamemoLike(String value) {
                addCriterion("datamemo like", value, "datamemo");
                return (Criteria) this;
            }

            public Criteria andDatamemoNotLike(String value) {
                addCriterion("datamemo not like", value, "datamemo");
                return (Criteria) this;
            }

            public Criteria andDatamemoIn(List<String> values) {
                addCriterion("datamemo in", values, "datamemo");
                return (Criteria) this;
            }

            public Criteria andDatamemoNotIn(List<String> values) {
                addCriterion("datamemo not in", values, "datamemo");
                return (Criteria) this;
            }

            public Criteria andDatamemoBetween(String value1, String value2) {
                addCriterion("datamemo between", value1, value2, "datamemo");
                return (Criteria) this;
            }

            public Criteria andDatamemoNotBetween(String value1, String value2) {
                addCriterion("datamemo not between", value1, value2, "datamemo");
                return (Criteria) this;
            }

        
            public Criteria andValueIsNull() {
                addCriterion("value is null");
                return (Criteria) this;
            }

            public Criteria andValueIsNotNull() {
                addCriterion("value is not null");
                return (Criteria) this;
            }

            public Criteria andValueEqualTo(String value) {
                addCriterion("value =", value, "value");
                return (Criteria) this;
            }

            public Criteria andValueNotEqualTo(String value) {
                addCriterion("value <>", value, "value");
                return (Criteria) this;
            }

            public Criteria andValueGreaterThan(String value) {
                addCriterion("value >", value, "value");
                return (Criteria) this;
            }

            public Criteria andValueGreaterThanOrEqualTo(String value) {
                addCriterion("value >=", value, "value");
                return (Criteria) this;
            }

            public Criteria andValueLessThan(String value) {
                addCriterion("value <", value, "value");
                return (Criteria) this;
            }

            public Criteria andValueLessThanOrEqualTo(String value) {
                addCriterion("value <=", value, "value");
                return (Criteria) this;
            }

            public Criteria andValueLike(String value) {
                addCriterion("value like", value, "value");
                return (Criteria) this;
            }

            public Criteria andValueNotLike(String value) {
                addCriterion("value not like", value, "value");
                return (Criteria) this;
            }

            public Criteria andValueIn(List<String> values) {
                addCriterion("value in", values, "value");
                return (Criteria) this;
            }

            public Criteria andValueNotIn(List<String> values) {
                addCriterion("value not in", values, "value");
                return (Criteria) this;
            }

            public Criteria andValueBetween(String value1, String value2) {
                addCriterion("value between", value1, value2, "value");
                return (Criteria) this;
            }

            public Criteria andValueNotBetween(String value1, String value2) {
                addCriterion("value not between", value1, value2, "value");
                return (Criteria) this;
            }

        
            public Criteria andTargetidIsNull() {
                addCriterion("targetid is null");
                return (Criteria) this;
            }

            public Criteria andTargetidIsNotNull() {
                addCriterion("targetid is not null");
                return (Criteria) this;
            }

            public Criteria andTargetidEqualTo(String value) {
                addCriterion("targetid =", value, "targetid");
                return (Criteria) this;
            }

            public Criteria andTargetidNotEqualTo(String value) {
                addCriterion("targetid <>", value, "targetid");
                return (Criteria) this;
            }

            public Criteria andTargetidGreaterThan(String value) {
                addCriterion("targetid >", value, "targetid");
                return (Criteria) this;
            }

            public Criteria andTargetidGreaterThanOrEqualTo(String value) {
                addCriterion("targetid >=", value, "targetid");
                return (Criteria) this;
            }

            public Criteria andTargetidLessThan(String value) {
                addCriterion("targetid <", value, "targetid");
                return (Criteria) this;
            }

            public Criteria andTargetidLessThanOrEqualTo(String value) {
                addCriterion("targetid <=", value, "targetid");
                return (Criteria) this;
            }

            public Criteria andTargetidLike(String value) {
                addCriterion("targetid like", value, "targetid");
                return (Criteria) this;
            }

            public Criteria andTargetidNotLike(String value) {
                addCriterion("targetid not like", value, "targetid");
                return (Criteria) this;
            }

            public Criteria andTargetidIn(List<String> values) {
                addCriterion("targetid in", values, "targetid");
                return (Criteria) this;
            }

            public Criteria andTargetidNotIn(List<String> values) {
                addCriterion("targetid not in", values, "targetid");
                return (Criteria) this;
            }

            public Criteria andTargetidBetween(String value1, String value2) {
                addCriterion("targetid between", value1, value2, "targetid");
                return (Criteria) this;
            }

            public Criteria andTargetidNotBetween(String value1, String value2) {
                addCriterion("targetid not between", value1, value2, "targetid");
                return (Criteria) this;
            }

        
            public Criteria andTaskidIsNull() {
                addCriterion("taskid is null");
                return (Criteria) this;
            }

            public Criteria andTaskidIsNotNull() {
                addCriterion("taskid is not null");
                return (Criteria) this;
            }

            public Criteria andTaskidEqualTo(String value) {
                addCriterion("taskid =", value, "taskid");
                return (Criteria) this;
            }

            public Criteria andTaskidNotEqualTo(String value) {
                addCriterion("taskid <>", value, "taskid");
                return (Criteria) this;
            }

            public Criteria andTaskidGreaterThan(String value) {
                addCriterion("taskid >", value, "taskid");
                return (Criteria) this;
            }

            public Criteria andTaskidGreaterThanOrEqualTo(String value) {
                addCriterion("taskid >=", value, "taskid");
                return (Criteria) this;
            }

            public Criteria andTaskidLessThan(String value) {
                addCriterion("taskid <", value, "taskid");
                return (Criteria) this;
            }

            public Criteria andTaskidLessThanOrEqualTo(String value) {
                addCriterion("taskid <=", value, "taskid");
                return (Criteria) this;
            }

            public Criteria andTaskidLike(String value) {
                addCriterion("taskid like", value, "taskid");
                return (Criteria) this;
            }

            public Criteria andTaskidNotLike(String value) {
                addCriterion("taskid not like", value, "taskid");
                return (Criteria) this;
            }

            public Criteria andTaskidIn(List<String> values) {
                addCriterion("taskid in", values, "taskid");
                return (Criteria) this;
            }

            public Criteria andTaskidNotIn(List<String> values) {
                addCriterion("taskid not in", values, "taskid");
                return (Criteria) this;
            }

            public Criteria andTaskidBetween(String value1, String value2) {
                addCriterion("taskid between", value1, value2, "taskid");
                return (Criteria) this;
            }

            public Criteria andTaskidNotBetween(String value1, String value2) {
                addCriterion("taskid not between", value1, value2, "taskid");
                return (Criteria) this;
            }

        
            public Criteria andIsfinishIsNull() {
                addCriterion("isfinish is null");
                return (Criteria) this;
            }

            public Criteria andIsfinishIsNotNull() {
                addCriterion("isfinish is not null");
                return (Criteria) this;
            }

            public Criteria andIsfinishEqualTo(String value) {
                addCriterion("isfinish =", value, "isfinish");
                return (Criteria) this;
            }

            public Criteria andIsfinishNotEqualTo(String value) {
                addCriterion("isfinish <>", value, "isfinish");
                return (Criteria) this;
            }

            public Criteria andIsfinishGreaterThan(String value) {
                addCriterion("isfinish >", value, "isfinish");
                return (Criteria) this;
            }

            public Criteria andIsfinishGreaterThanOrEqualTo(String value) {
                addCriterion("isfinish >=", value, "isfinish");
                return (Criteria) this;
            }

            public Criteria andIsfinishLessThan(String value) {
                addCriterion("isfinish <", value, "isfinish");
                return (Criteria) this;
            }

            public Criteria andIsfinishLessThanOrEqualTo(String value) {
                addCriterion("isfinish <=", value, "isfinish");
                return (Criteria) this;
            }

            public Criteria andIsfinishLike(String value) {
                addCriterion("isfinish like", value, "isfinish");
                return (Criteria) this;
            }

            public Criteria andIsfinishNotLike(String value) {
                addCriterion("isfinish not like", value, "isfinish");
                return (Criteria) this;
            }

            public Criteria andIsfinishIn(List<String> values) {
                addCriterion("isfinish in", values, "isfinish");
                return (Criteria) this;
            }

            public Criteria andIsfinishNotIn(List<String> values) {
                addCriterion("isfinish not in", values, "isfinish");
                return (Criteria) this;
            }

            public Criteria andIsfinishBetween(String value1, String value2) {
                addCriterion("isfinish between", value1, value2, "isfinish");
                return (Criteria) this;
            }

            public Criteria andIsfinishNotBetween(String value1, String value2) {
                addCriterion("isfinish not between", value1, value2, "isfinish");
                return (Criteria) this;
            }

        
            public Criteria andCreatetimeIsNull() {
                addCriterion("createtime is null");
                return (Criteria) this;
            }

            public Criteria andCreatetimeIsNotNull() {
                addCriterion("createtime is not null");
                return (Criteria) this;
            }

            public Criteria andCreatetimeEqualTo(Date value) {
                addCriterion("createtime =", value, "createtime");
                return (Criteria) this;
            }

            public Criteria andCreatetimeNotEqualTo(Date value) {
                addCriterion("createtime <>", value, "createtime");
                return (Criteria) this;
            }

            public Criteria andCreatetimeGreaterThan(Date value) {
                addCriterion("createtime >", value, "createtime");
                return (Criteria) this;
            }

            public Criteria andCreatetimeGreaterThanOrEqualTo(Date value) {
                addCriterion("createtime >=", value, "createtime");
                return (Criteria) this;
            }

            public Criteria andCreatetimeLessThan(Date value) {
                addCriterion("createtime <", value, "createtime");
                return (Criteria) this;
            }

            public Criteria andCreatetimeLessThanOrEqualTo(Date value) {
                addCriterion("createtime <=", value, "createtime");
                return (Criteria) this;
            }

            public Criteria andCreatetimeLike(Date value) {
                addCriterion("createtime like", value, "createtime");
                return (Criteria) this;
            }

            public Criteria andCreatetimeNotLike(Date value) {
                addCriterion("createtime not like", value, "createtime");
                return (Criteria) this;
            }

            public Criteria andCreatetimeIn(List<Date> values) {
                addCriterion("createtime in", values, "createtime");
                return (Criteria) this;
            }

            public Criteria andCreatetimeNotIn(List<Date> values) {
                addCriterion("createtime not in", values, "createtime");
                return (Criteria) this;
            }

            public Criteria andCreatetimeBetween(Date value1, Date value2) {
                addCriterion("createtime between", value1, value2, "createtime");
                return (Criteria) this;
            }

            public Criteria andCreatetimeNotBetween(Date value1, Date value2) {
                addCriterion("createtime not between", value1, value2, "createtime");
                return (Criteria) this;
            }

        
        public Criteria andLikeQuery(RpaTransdata record) {
            List<String> list = new ArrayList<String>();
            List<String> list2 = new ArrayList<String>();
            StringBuffer buffer = new StringBuffer();
                            if (record.getId() != null && StrUtil.isNotEmpty(record.getId().toString())) {
                    list.add("ifnull(id,'')");
                }
                            if (record.getTypenum() != null && StrUtil.isNotEmpty(record.getTypenum().toString())) {
                    list.add("ifnull(typenum,'')");
                }
                            if (record.getTypename() != null && StrUtil.isNotEmpty(record.getTypename().toString())) {
                    list.add("ifnull(typename,'')");
                }
                            if (record.getThirdid() != null && StrUtil.isNotEmpty(record.getThirdid().toString())) {
                    list.add("ifnull(thirdid,'')");
                }
                            if (record.getTaskmonth() != null && StrUtil.isNotEmpty(record.getTaskmonth().toString())) {
                    list.add("ifnull(taskmonth,'')");
                }
                            if (record.getSubcompanyname() != null && StrUtil.isNotEmpty(record.getSubcompanyname().toString())) {
                    list.add("ifnull(subcompanyname,'')");
                }
                            if (record.getSupplyname() != null && StrUtil.isNotEmpty(record.getSupplyname().toString())) {
                    list.add("ifnull(supplyname,'')");
                }
                            if (record.getSelfsupplyid() != null && StrUtil.isNotEmpty(record.getSelfsupplyid().toString())) {
                    list.add("ifnull(selfsupplyid,'')");
                }
                            if (record.getSelfsupplyname() != null && StrUtil.isNotEmpty(record.getSelfsupplyname().toString())) {
                    list.add("ifnull(selfsupplyname,'')");
                }
                            if (record.getDatamemo() != null && StrUtil.isNotEmpty(record.getDatamemo().toString())) {
                    list.add("ifnull(datamemo,'')");
                }
                            if (record.getValue() != null && StrUtil.isNotEmpty(record.getValue().toString())) {
                    list.add("ifnull(value,'')");
                }
                            if (record.getTargetid() != null && StrUtil.isNotEmpty(record.getTargetid().toString())) {
                    list.add("ifnull(targetid,'')");
                }
                            if (record.getTaskid() != null && StrUtil.isNotEmpty(record.getTaskid().toString())) {
                    list.add("ifnull(taskid,'')");
                }
                            if (record.getIsfinish() != null && StrUtil.isNotEmpty(record.getIsfinish().toString())) {
                    list.add("ifnull(isfinish,'')");
                }
                            if (record.getCreatetime() != null && StrUtil.isNotEmpty(record.getCreatetime().toString())) {
                    list.add("ifnull(createtime,'')");
                }
                                        if (record.getId() != null && StrUtil.isNotEmpty(record.getId().toString())) {
                    list2.add("'%" + record.getId() + "%'");
                }
                            if (record.getTypenum() != null && StrUtil.isNotEmpty(record.getTypenum().toString())) {
                    list2.add("'%" + record.getTypenum() + "%'");
                }
                            if (record.getTypename() != null && StrUtil.isNotEmpty(record.getTypename().toString())) {
                    list2.add("'%" + record.getTypename() + "%'");
                }
                            if (record.getThirdid() != null && StrUtil.isNotEmpty(record.getThirdid().toString())) {
                    list2.add("'%" + record.getThirdid() + "%'");
                }
                            if (record.getTaskmonth() != null && StrUtil.isNotEmpty(record.getTaskmonth().toString())) {
                    list2.add("'%" + record.getTaskmonth() + "%'");
                }
                            if (record.getSubcompanyname() != null && StrUtil.isNotEmpty(record.getSubcompanyname().toString())) {
                    list2.add("'%" + record.getSubcompanyname() + "%'");
                }
                            if (record.getSupplyname() != null && StrUtil.isNotEmpty(record.getSupplyname().toString())) {
                    list2.add("'%" + record.getSupplyname() + "%'");
                }
                            if (record.getSelfsupplyid() != null && StrUtil.isNotEmpty(record.getSelfsupplyid().toString())) {
                    list2.add("'%" + record.getSelfsupplyid() + "%'");
                }
                            if (record.getSelfsupplyname() != null && StrUtil.isNotEmpty(record.getSelfsupplyname().toString())) {
                    list2.add("'%" + record.getSelfsupplyname() + "%'");
                }
                            if (record.getDatamemo() != null && StrUtil.isNotEmpty(record.getDatamemo().toString())) {
                    list2.add("'%" + record.getDatamemo() + "%'");
                }
                            if (record.getValue() != null && StrUtil.isNotEmpty(record.getValue().toString())) {
                    list2.add("'%" + record.getValue() + "%'");
                }
                            if (record.getTargetid() != null && StrUtil.isNotEmpty(record.getTargetid().toString())) {
                    list2.add("'%" + record.getTargetid() + "%'");
                }
                            if (record.getTaskid() != null && StrUtil.isNotEmpty(record.getTaskid().toString())) {
                    list2.add("'%" + record.getTaskid() + "%'");
                }
                            if (record.getIsfinish() != null && StrUtil.isNotEmpty(record.getIsfinish().toString())) {
                    list2.add("'%" + record.getIsfinish() + "%'");
                }
                            if (record.getCreatetime() != null && StrUtil.isNotEmpty(record.getCreatetime().toString())) {
                    list2.add("'%" + record.getCreatetime() + "%'");
                }
                        buffer.append(" CONCAT(");
            buffer.append(StrUtil.join(",", list));
            buffer.append(")");
            buffer.append(" like CONCAT(");
            buffer.append(StrUtil.join(",", list2));
            buffer.append(")");
            if (!" CONCAT() like CONCAT()".equals(buffer.toString())) {
                addCriterion(buffer.toString());
            }
            return (Criteria) this;
        }

        public Criteria andLikeQuery2(String searchText) {
            List<String> list = new ArrayList<String>();
            StringBuffer buffer = new StringBuffer();
                            list.add("ifnull(id,'')");
                            list.add("ifnull(typenum,'')");
                            list.add("ifnull(typename,'')");
                            list.add("ifnull(thirdid,'')");
                            list.add("ifnull(taskmonth,'')");
                            list.add("ifnull(subcompanyname,'')");
                            list.add("ifnull(supplyname,'')");
                            list.add("ifnull(selfsupplyid,'')");
                            list.add("ifnull(selfsupplyname,'')");
                            list.add("ifnull(datamemo,'')");
                            list.add("ifnull(value,'')");
                            list.add("ifnull(targetid,'')");
                            list.add("ifnull(taskid,'')");
                            list.add("ifnull(isfinish,'')");
                            list.add("ifnull(createtime,'')");
                        buffer.append(" CONCAT(");
            buffer.append(StrUtil.join(",", list));
            buffer.append(")");
            buffer.append("like '%");
            buffer.append(searchText);
            buffer.append("%'");
            addCriterion(buffer.toString());
            return (Criteria) this;
        }

    }

    public static class Criteria extends GeneratedCriteria {
        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}